-- SQL Loader Control and Data File created by TOAD
-- Variable length, terminated enclosed data formatting
--
-- The format for executing this file with SQL Loader is:
-- SQLLDR control=<filename> Be sure to substitute your
-- version of SQL LOADER and the filename for this file.
LOAD DATA
INFILE *
BADFILE './tmatch.BAD'
DISCARDFILE './tmatch.DSC'
APPEND INTO TABLE TOTE.TMATCH
Fields terminated by ";" Optionally enclosed by '"'
(
  MATCHID NULLIF (MATCHID="NULL"),
  MATCHDATE DATE "DD/MM HH24:MI",
  venue,
  TEAMID1 NULLIF (TEAMID1="NULL"),
  TEAMID2 NULLIF (TEAMID2="NULL"),
  tourid,
  NOTE,
  matchurl,
  STATUS_ NULLIF (STATUS_="NULL")
)
BEGINDATA
49;26/06 17:00;Nelson Mandela Bay/Port Elizabeth;3;7;4;Round of 16;http://www.fifa.com/worldcup/matches/index.html;210
50;26/06 21:30;Rustenburg;10;16;4;Round of 16;http://www.fifa.com/worldcup/matches/index.html;210
51;27/06 17:00;Mangaung/Bloemfontein;13;9;4;Round of 16;http://www.fifa.com/worldcup/matches/index.html;210
52;27/06 21:30;Johannesburg;5;2;4;Round of 16;http://www.fifa.com/worldcup/matches/index.html;210
53;28/06 17:00;Durban;0;0;4;Round of 16;http://www.fifa.com/worldcup/matches/index.html;210
54;28/06 21:30;Johannesburg;0;0;4;Round of 16;http://www.fifa.com/worldcup/matches/index.html;210
55;29/06 17:00;Tshwane/Pretoria;0;0;4;Round of 16;http://www.fifa.com/worldcup/matches/index.html;210
56;29/06 21:30;Cape Town;0;0;4;Round of 16;http://www.fifa.com/worldcup/matches/index.html;210
57;02/07 17:00;Nelson Mandela Bay/Port Elizabeth;0;0;5;Quarter-finals;http://www.fifa.com/worldcup/matches/index.html;210
58;02/07 21:30;Johannesburg;0;0;5;Quarter-finals;http://www.fifa.com/worldcup/matches/index.html;210
59;03/07 17:00;Cape Town;0;0;5;Quarter-finals;http://www.fifa.com/worldcup/matches/index.html;210
60;03/07 21:30;Johannesburg;0;0;5;Quarter-finals;http://www.fifa.com/worldcup/matches/index.html;210
61;06/07 21:30;Cape Town;0;0;6;Semi-finals;http://www.fifa.com/worldcup/matches/index.html;210
62;07/07 21:30;Durban;0;0;6;Semi-finals;http://www.fifa.com/worldcup/matches/index.html;210
63;10/07 21:30;Nelson Mandela Bay/Port Elizabeth;0;0;7;Match for third place;http://www.fifa.com/worldcup/matches/index.html;210
64;11/07 21:30;Johannesburg;0;0;7;FinalMatch;http://www.fifa.com/worldcup/matches/index.html;210
